//繼路使用者及訂單基本資料並自動導向

			$SSN  = isset($_SESSION['customer']->SSN)?$_SESSION['customer']->SSN:"unknown";
			$name = isset($_SESSION['customer']->name)?$_SESSION['customer']->name:"unknown";
			$tel = isset($_SESSION['customer']->tel)?$_SESSION['customer']->tel:"unknown";
			$email = isset($_SESSION['customer']->email)?$_SESSION['customer']->email:"unknown";
			
			$sql = "INSERT INTO customer
			        VALUES ('$SSN', '$name', '$tel' , '$email')";
			mysql_db_query($db , $sql);
			
			$date = getdate();
			$order_date = $date['year'].'/'.$date['mon'].'/'.$date['mday'];
			$total_cost = total_cost();
			$ID = $SSN;
			
			$sql = "INSERT INTO `order` VALUES('', '".$order_date."', '".$total_cost."', '".$ID."')";
			mysql_db_query($db , $sql);
			
			$sql = "SELECT DISTINCT order_number FROM `order` WHERE order_date = '".$order_date."' AND total_cost = '".$total_cost."' AND ID = '".$ID."'";
			$search = mysql_db_query($db , $sql);
			list($order_number) = mysql_fetch_array($search);
			
			foreach($_SESSION['bag']->lunchbox_number as $lunchbox_number)
		  {
		      $quantity = $_SESSION['bag']->quantity[$lunchbox_number];	
		      
		      $sql = "INSERT INTO `quantity` VALUES ('".$order_number."','".$lunchbox_number."', '".$quantity."')";
		      mysql_db_query($db , $sql);
		  }
			
header("Location: order.php");

function total_cost()
{
	$total = 0;
	foreach($_SESSION['bag']->lunchbox_number as $lunchbox_number)
  {
  	 $total = $total + $_SESSION['bag']->price[$lunchbox_number];
  }	
  return $total;

//increse_order()

class order
	{
		var $bag;
		var $customer_ssn;
	
		function order($bag_obj, $c_ssn)
		{
			$this->bag = $bag_obj;
			$this->customer_ssn =  $c_ssn;
		}
	
		function increase_order()
		{
			
			mysql_select_db ("SA&D");
			$query = "INSERT INTO orderform (order_number, order_date , total_cost , SSN) VALUES ('', NOW(),'". $this->bag->count_total_cost()."', '".$this->customer_ssn."')";
			
			mysql_query($query);	
			
			$ordernb = mysql_insert_id();
		
			foreach ($this->bag->lunchbox_number as $lunchbox_number_t)
			{
				$query2="INSERT INTO order_content(lunchbox_number ,price ,quantity ,   single_cost  ,order_number )VALUES('".$lunchbox_number_t."','".$this->bag->price[$lunchbox_number_t]."','".$this->bag->quantity[$lunchbox_number_t]."','".$this->bag-> single_cost[$lunchbox_number_t]."',$ordernb)";
				echo "<BR>";
				mysql_query($query2);
			}
			
			return $ordernb;
		}
	}

$order = new order( $_SESSION["bag"], $_SESSION["customer"]->SSN);
$order->increase_order();